KW looking at patterns of prevalence using all variables
2018-12-20
Joining, by = "question_text"
LS0tCnRpdGxlOiAiS1cgbG9va2luZyBhdCBwYXR0ZXJucyBvZiBwcmV2YWxlbmNlIHVzaW5nIGFsbCB2YXJpYWJsZXMiCmRhdGU6IDIwMTgtMTItMjAKb3V0cHV0OiAKICBodG1sX25vdGVib29rOgogICAgdG9jOiB0cnVlCiAgICB0b2NfZmxvYXQ6IHRydWUKLS0tCgpgYGB7cn0KdGVtcCA8LSBkZl9hbGxfcmVzcCAlPiUKICBzZWxlY3QodGF2ZXNfY3RyeSwgcXVlc3Rpb25fdGV4dCwgZW5kc193aXRoKCJtZWFuIikpICU+JQogIG11dGF0ZShhYnNfdmFsX21lYW4gPSBhYnModmFsX21lYW4pKSAlPiUKICBnYXRoZXIoaW5kZXgsIHNjb3JlLCBlbmRzX3dpdGgoIm1lYW4iKSkgJT4lCiAgYXJyYW5nZSh0YXZlc19jdHJ5LCBxdWVzdGlvbl90ZXh0LCBpbmRleCkgJT4lCiAgbXV0YXRlKHNpdGVfaW5kZXggPSBwYXN0ZSh0YXZlc19jdHJ5LCBpbmRleCwgc2VwID0gIl8iKSkgJT4lCiAgc2VsZWN0KHF1ZXN0aW9uX3RleHQsIHNpdGVfaW5kZXgsIHNjb3JlKSAlPiUKICBzcHJlYWQocXVlc3Rpb25fdGV4dCwgc2NvcmUpICU+JQogIGNvbHVtbl90b19yb3duYW1lcygic2l0ZV9pbmRleCIpCmBgYAoKYGBge3J9CmhjbHVzdF9hbGwgPC0gdGVtcCAlPiUKICB0KCkgJT4lCiAgZGlzdCgpICU+JQogIGhjbHVzdCgpCmBgYAoKYGBge3IsIGZpZy53aWR0aCA9IDgsIGZpZy5hc3AgPSAxfQpoY2x1c3RfYWxsICU+JSAKICBhcy5kZW5kcm9ncmFtKCkgJT4lIAogIHNldCgibGFiZWxzX2NvbCIsIGsgPSA5LCB2YWx1ZSA9IGMoIiNhNmNlZTMiLCAiIzFmNzhiNCIsICIjYjJkZjhhIiwKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICIjMzNhMDJjIiwgIiNmYjlhOTkiLCAiI2UzMWExYyIsIAogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIiNmZGJmNmYiLCAiI2ZmN2YwMCIsICIjY2FiMmQ2IikpICU+JSAKICBwbG90KGhvcml6ID0gVCwgeGxpbSA9IGMoMywgLTEwKSwgYXhlcyA9IEYpCmBgYAoKYGBge3J9CnRlbXBfZGYgPC0gZGF0YS5mcmFtZShjbHVzdGVyID0gY3V0cmVlKGhjbHVzdF9hbGwsIDkpKSAlPiUKICByb3duYW1lc190b19jb2x1bW4oInF1ZXN0aW9uX3RleHQiKSAlPiUKICBtdXRhdGUobGV2ZWwxID0gY2FzZV93aGVuKGNsdXN0ZXIgJWluJSBjKDEsIDMsIDgsIDksIDUpIH4gIjEzODk1IiwKICAgICAgICAgICAgICAgICAgICAgICAgICAgIGNsdXN0ZXIgJWluJSBjKDQsIDYsIDIsIDcpIH4gIjQ2MjciKSwKICAgICAgICAgbGV2ZWwyYSA9IGNhc2Vfd2hlbihjbHVzdGVyICVpbiUgYygxLCAzKSB+ICIxMyIsCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgY2x1c3RlciAlaW4lIGMoOCwgOSwgNSkgfiAiODk1IiksCiAgICAgICAgIGxldmVsMmIgPSBjYXNlX3doZW4oY2x1c3RlciAlaW4lIGMoNCwgNiwgMikgfiAiNDYyIiwKICAgICAgICAgICAgICAgICAgICAgICAgICAgICBjbHVzdGVyICVpbiUgYyg3KSB+ICI3IiksCiAgICAgICAgIGxldmVsMiA9IGNhc2Vfd2hlbihjbHVzdGVyICVpbiUgYygxLCAzKSB+ICIxMyIsCiAgICAgICAgICAgICAgICAgICAgICAgICAgICBjbHVzdGVyICVpbiUgYyg4LCA5LCA1KSB+ICI4OTUiLAogICAgICAgICAgICAgICAgICAgICAgICAgICAgY2x1c3RlciAlaW4lIGMoNCwgNiwgMikgfiAiNDYyIiwKICAgICAgICAgICAgICAgICAgICAgICAgICAgIGNsdXN0ZXIgJWluJSBjKDcpIH4gIjciKSwKICAgICAgICAgbGV2ZWwxID0gZmFjdG9yKGxldmVsMSwgbGV2ZWxzID0gYygiMTM4OTUiLCAiNDYyNyIpKSwKICAgICAgICAgbGV2ZWwyYSA9IGZhY3RvcihsZXZlbDJhLCBsZXZlbHMgPSBjKCIxMyIsICI4OTUiKSksCiAgICAgICAgIGxldmVsMmIgPSBmYWN0b3IobGV2ZWwyYiwgbGV2ZWxzID0gYygiNDYyIiwgIjciKSksCiAgICAgICAgIGxldmVsMiA9IGZhY3RvcihsZXZlbDIsIGxldmVscyA9IGMoIjEzIiwgIjg5NSIsICI0NjIiLCAiNyIpKSkgJT4lCiAgZnVsbF9qb2luKGRmX2FsbF9yZXNwICU+JSAKICAgICAgICAgICAgICByZW5hbWUocHJldl9jbHVzdGVyID0gY2x1c3RlciwKICAgICAgICAgICAgICAgICAgICAgcHJldl9sZXZlbDEgPSBsZXZlbDEsCiAgICAgICAgICAgICAgICAgICAgIHByZXZfbGV2ZWwyID0gbGV2ZWwyLAogICAgICAgICAgICAgICAgICAgICBwcmV2X2xldmVsMnVuY29tbW9uID0gbGV2ZWwydW5jb21tb24sCiAgICAgICAgICAgICAgICAgICAgIHByZXZfbGV2ZWwyY29tbW9uID0gbGV2ZWwyY29tbW9uLAogICAgICAgICAgICAgICAgICAgICBwcmV2X2xldmVsMyA9IGxldmVsMykgJT4lCiAgICAgICAgICAgICAgbXV0YXRlKGFic192YWxfbWVhbiA9IGFicyh2YWxfbWVhbikpKQpgYGAKCmBgYHtyfQp0ZW1wX2RmICU+JQogIGNvdW50KGNsdXN0ZXIsIHByZXZfY2x1c3RlcikKYGBgCgpgYGB7ciwgZmlnLndpZHRoID0gNiwgZmlnLmFzcCA9IDAuOH0KdGVtcF9kZiAlPiUKICBnZ3Bsb3QoYWVzKHggPSBxdWVzdGlvbiwgeSA9IHByZXZfbWVhbiwgY29sb3IgPSB0YXZlc19jdHJ5LCBsYWJlbCA9IHByZXZfbikpICsKICBmYWNldF9ncmlkKGNvbHMgPSB2YXJzKGxldmVsMSwgbGV2ZWwyLCBjbHVzdGVyKSwgCiAgICAgICAgICAgICByb3dzID0gdmFycyh0YXZlc19jdHJ5KSwgCiAgICAgICAgICAgICBzY2FsZXMgPSAiZnJlZV94Iiwgc3BhY2UgPSAiZnJlZV94IikgKwogIGdlb21faGxpbmUoeWludGVyY2VwdCA9IDAuNSwgbHR5ID0gMikgKwogIGdlb21fcG9pbnRyYW5nZShhZXMoeW1pbiA9IHByZXZfY2lfbG93ZXIsIHltYXggPSBwcmV2X2NpX3VwcGVyKSkgKwogIGdlb21fdGV4dChzaXplID0gMiwgeSA9IDAuMDUsIGNvbG9yID0gImJsYWNrIikgKwogIHNjYWxlX2NvbG9yX2JyZXdlcihwYWxldHRlID0gIlNldDIiKSArCiAgeWxpbSgwLCAxKSArCiAgdGhlbWVfYncoKSArCiAgdGhlbWUoYXhpcy50ZXh0LnggPSBlbGVtZW50X3RleHQoYW5nbGUgPSA0NSwgaGp1c3QgPSAxLCB2anVzdCA9IDEpLAogICAgICAgIGxlZ2VuZC5wb3NpdGlvbiA9ICJub25lIikgKwogIGxhYnModGl0bGUgPSAiQ2x1c3RlcmluZyB3aXRoIGFsbCB2YXJpYWJsZXMgUFJFVkFMRU5DRTogUHJvcG9ydGlvbiBvZiBwYXJ0aWNpcGFudHMgd2hvIGVuZG9yc2VkIGV4cGVyaWVuY2UiLAogICAgICAgc3VidGl0bGUgPSAiQnkgc2l0ZSAocm93cyksIHF1ZXN0aW9uICh4LWF4aXMpLCBhbmQgbGV2ZWxzIDEtMiBncm91cGluZyBvZiBjbHVzdGVycyAoY29sdW1ucylcbk51bWJlcnMgZm9yIGVhY2ggcXVlc3Rpb24gaW5kaWNhdGUgdGhlIHRvdGFsIG51bWJlciBvZiBwYXJ0aWNpcGFudHMgZnJvbSB0aGF0IHNpdGUgd2hvIHJlc3BvbmRlZCB0byB0aGF0IHF1ZXN0aW9uOyBlcnJvciBiYXJzIGFyZSA5NSUgYm9vdHN0cmFwcGVkIENJcyIsCiAgICAgICB4ID0gIlF1ZXN0aW9uIiwKICAgICAgIHkgPSAiUHJldmFsZW5jZSAoMC0xKSIsIGNvbG9yID0gIlNpdGUiKQpgYGAKCjxQIHN0eWxlPSJwYWdlLWJyZWFrLWJlZm9yZTogYWx3YXlzIj4KYGBge3IsIGZpZy53aWR0aCA9IDYsIGZpZy5hc3AgPSAwLjh9CnRlbXBfZGYgJT4lCiAgZ2dwbG90KGFlcyh4ID0gcXVlc3Rpb24sIHkgPSBhcHBfbWVhbiwgY29sb3IgPSB0YXZlc19jdHJ5LCBsYWJlbCA9IGFwcF9uKSkgKwogIGZhY2V0X2dyaWQoY29scyA9IHZhcnMobGV2ZWwxLCBsZXZlbDIsIGNsdXN0ZXIpLCAKICAgICAgICAgICAgIHJvd3MgPSB2YXJzKHRhdmVzX2N0cnkpLCAKICAgICAgICAgICAgIHNjYWxlcyA9ICJmcmVlX3giLCBzcGFjZSA9ICJmcmVlX3giKSArCiAgZ2VvbV9obGluZSh5aW50ZXJjZXB0ID0gMCwgbHR5ID0gMikgKwogIGdlb21fcG9pbnRyYW5nZShhZXMoeW1pbiA9IGFwcF9jaV9sb3dlciwgeW1heCA9IGFwcF9jaV91cHBlcikpICsKICBnZW9tX3RleHQoc2l6ZSA9IDIsIHkgPSAtMC45NSwgY29sb3IgPSAiYmxhY2siKSArCiAgc2NhbGVfY29sb3JfYnJld2VyKHBhbGV0dGUgPSAiU2V0MiIpICsKICB5bGltKC0xLCAxKSArCiAgdGhlbWVfYncoKSArCiAgdGhlbWUoYXhpcy50ZXh0LnggPSBlbGVtZW50X3RleHQoYW5nbGUgPSA0NSwgaGp1c3QgPSAxLCB2anVzdCA9IDEpLAogICAgICAgIGxlZ2VuZC5wb3NpdGlvbiA9ICJub25lIikgKwogIGxhYnModGl0bGUgPSAiQ2x1c3RlcmluZyB3aXRoIGFsbCB2YXJpYWJsZXMgQVBQUkFJU0FMOiBNZWFuIHJlc3BvbnNlIHRvIHdoZXRoZXIgdGhlIHBhcnRpY2lwYW50IGFwcHJhaXNlZCBleHBlcmllbmNlIGFzIHJlbGlnaW91cy9zcGlyaXR1YWwiLAogICAgICAgc3VidGl0bGUgPSAiQnkgc2l0ZSAocm93cyksIHF1ZXN0aW9uICh4LWF4aXMpLCBhbmQgbGV2ZWxzIDEtMiBncm91cGluZyBvZiBjbHVzdGVycyAoY29sdW1ucylcbk51bWJlcnMgZm9yIGVhY2ggcXVlc3Rpb24gaW5kaWNhdGUgdGhlIHRvdGFsIG51bWJlciBvZiBwYXJ0aWNpcGFudHMgZnJvbSB0aGF0IHNpdGUgd2hvIHJlc3BvbmRlZCB0byB0aGF0IHF1ZXN0aW9uOyBlcnJvciBiYXJzIGFyZSA5NSUgYm9vdHN0cmFwcGVkIENJcyIsCiAgICAgICB4ID0gIlF1ZXN0aW9uIiwKICAgICAgIHkgPSAiQXBwcmFpc2FsICgtMTogbm8sIDA6IHVuc3VyZSwgKzE6IHllcykiLCBjb2xvciA9ICJTaXRlIikKYGBgCgo8UCBzdHlsZT0icGFnZS1icmVhay1iZWZvcmU6IGFsd2F5cyI+CmBgYHtyLCBmaWcud2lkdGggPSA2LCBmaWcuYXNwID0gMC44fQp0ZW1wX2RmICU+JQogIGdncGxvdChhZXMoeCA9IHF1ZXN0aW9uLCB5ID0gdmFsX21lYW4sIGNvbG9yID0gdGF2ZXNfY3RyeSwgbGFiZWwgPSB2YWxfbikpICsKICBmYWNldF9ncmlkKGNvbHMgPSB2YXJzKGxldmVsMSwgbGV2ZWwyLCBjbHVzdGVyKSwgCiAgICAgICAgICAgICByb3dzID0gdmFycyh0YXZlc19jdHJ5KSwgCiAgICAgICAgICAgICBzY2FsZXMgPSAiZnJlZV94Iiwgc3BhY2UgPSAiZnJlZV94IikgKwogIGdlb21faGxpbmUoeWludGVyY2VwdCA9IDAsIGx0eSA9IDIpICsKICBnZW9tX3BvaW50cmFuZ2UoYWVzKHltaW4gPSB2YWxfY2lfbG93ZXIsIHltYXggPSB2YWxfY2lfdXBwZXIpKSArCiAgZ2VvbV90ZXh0KHNpemUgPSAyLCB5ID0gLTAuOTUsIGNvbG9yID0gImJsYWNrIikgKwogIHNjYWxlX2NvbG9yX2JyZXdlcihwYWxldHRlID0gIlNldDIiKSArCiAgeWxpbSgtMSwgMSkgKwogIHRoZW1lX2J3KCkgKwogIHRoZW1lKGF4aXMudGV4dC54ID0gZWxlbWVudF90ZXh0KGFuZ2xlID0gNDUsIGhqdXN0ID0gMSwgdmp1c3QgPSAxKSwKICAgICAgICBsZWdlbmQucG9zaXRpb24gPSAibm9uZSIpICsKICBsYWJzKHRpdGxlID0gIkNsdXN0ZXJpbmcgd2l0aCBhbGwgdmFyaWFibGVzIFZBTEVOQ0U6IE1lYW4gcmVzcG9uc2UgdG8gd2hldGhlciBleHBlcmllbmNlIHdhcyBjb25zaWRlcmVkIHBvc2l0aXZlL25lZ2F0aXZlIiwKICAgICAgIHN1YnRpdGxlID0gIkJ5IHNpdGUgKHJvd3MpLCBxdWVzdGlvbiAoeC1heGlzKSwgYW5kIGxldmVscyAxLTIgZ3JvdXBpbmcgb2YgY2x1c3RlcnMgKGNvbHVtbnMpXG5OdW1iZXJzIGZvciBlYWNoIHF1ZXN0aW9uIGluZGljYXRlIHRoZSB0b3RhbCBudW1iZXIgb2YgcGFydGljaXBhbnRzIGZyb20gdGhhdCBzaXRlIHdobyByZXNwb25kZWQgdG8gdGhhdCBxdWVzdGlvbjsgZXJyb3IgYmFycyBhcmUgOTUlIGJvb3RzdHJhcHBlZCBDSXMiLAogICAgICAgeCA9ICJRdWVzdGlvbiIsCiAgICAgICB5ID0gIlZhbGVuY2UgKC0xOiBuZWdhdGl2ZSwgMDogbmV1dHJhbCwgKzE6IHBvc2l0aXZlKSIsIGNvbG9yID0gIlNpdGUiKQpgYGAKCmBgYHtyLCBmaWcud2lkdGggPSA2LCBmaWcuYXNwID0gMC44fQp0ZW1wX2RmICU+JQogIGdncGxvdChhZXMoeCA9IHF1ZXN0aW9uLCB5ID0gYWJzX3ZhbF9tZWFuLCBjb2xvciA9IHRhdmVzX2N0cnksIGxhYmVsID0gdmFsX24pKSArCiAgZmFjZXRfZ3JpZChjb2xzID0gdmFycyhsZXZlbDEsIGxldmVsMiwgY2x1c3RlciksIAogICAgICAgICAgICAgcm93cyA9IHZhcnModGF2ZXNfY3RyeSksIAogICAgICAgICAgICAgc2NhbGVzID0gImZyZWVfeCIsIHNwYWNlID0gImZyZWVfeCIpICsKICBnZW9tX2hsaW5lKHlpbnRlcmNlcHQgPSAwLjUsIGx0eSA9IDIpICsKICBnZW9tX3BvaW50KCkgKwogICMgZ2VvbV9wb2ludHJhbmdlKGFlcyh5bWluID0gdmFsX2NpX2xvd2VyLCB5bWF4ID0gdmFsX2NpX3VwcGVyKSkgKwogIGdlb21fdGV4dChzaXplID0gMiwgeSA9IDAuMDUsIGNvbG9yID0gImJsYWNrIikgKwogIHNjYWxlX2NvbG9yX2JyZXdlcihwYWxldHRlID0gIlNldDIiKSArCiAgeWxpbSgwLCAxKSArCiAgdGhlbWVfYncoKSArCiAgdGhlbWUoYXhpcy50ZXh0LnggPSBlbGVtZW50X3RleHQoYW5nbGUgPSA0NSwgaGp1c3QgPSAxLCB2anVzdCA9IDEpLAogICAgICAgIGxlZ2VuZC5wb3NpdGlvbiA9ICJub25lIikgKwogIGxhYnModGl0bGUgPSAiQ2x1c3RlcmluZyB3aXRoIGFsbCB2YXJpYWJsZXMgQUJTT0xVVEUgVkFMRU5DRTogTWVhbiBhYnNvbHV0ZSByZXNwb25zZSB0byB3aGV0aGVyIGV4cGVyaWVuY2Ugd2FzIGNvbnNpZGVyZWQgcG9zaXRpdmUvbmVnYXRpdmUiLAogICAgICAgc3VidGl0bGUgPSAiQnkgc2l0ZSAocm93cyksIHF1ZXN0aW9uICh4LWF4aXMpLCBhbmQgbGV2ZWxzIDEtMiBncm91cGluZyBvZiBjbHVzdGVycyAoY29sdW1ucylcbk51bWJlcnMgZm9yIGVhY2ggcXVlc3Rpb24gaW5kaWNhdGUgdGhlIHRvdGFsIG51bWJlciBvZiBwYXJ0aWNpcGFudHMgZnJvbSB0aGF0IHNpdGUgd2hvIHJlc3BvbmRlZCB0byB0aGF0IHF1ZXN0aW9uOyBlcnJvciBiYXJzIGFyZSA5NSUgYm9vdHN0cmFwcGVkIENJcyIsCiAgICAgICB4ID0gIlF1ZXN0aW9uIiwKICAgICAgIHkgPSAiVmFsZW5jZSAoMDogbmV1dHJhbCwgMTogbmVnYXRpdmUvcG9zaXRpdmUpIiwgY29sb3IgPSAiU2l0ZSIpCmBgYAoKPFAgc3R5bGU9InBhZ2UtYnJlYWstYmVmb3JlOiBhbHdheXMiPgpgYGB7ciwgZmlnLndpZHRoID0gNiwgZmlnLmFzcCA9IDAuOH0KdGVtcF9kZiAlPiUKICBnZ3Bsb3QoYWVzKHggPSBxdWVzdGlvbiwgeSA9IHNpZ19tZWFuLCBjb2xvciA9IHRhdmVzX2N0cnksIGxhYmVsID0gc2lnX24pKSArCiAgZmFjZXRfZ3JpZChjb2xzID0gdmFycyhsZXZlbDEsIGxldmVsMiwgY2x1c3RlciksIAogICAgICAgICAgICAgcm93cyA9IHZhcnModGF2ZXNfY3RyeSksIAogICAgICAgICAgICAgc2NhbGVzID0gImZyZWVfeCIsIHNwYWNlID0gImZyZWVfeCIpICsKICBnZW9tX2hsaW5lKHlpbnRlcmNlcHQgPSAwLjUsIGx0eSA9IDIpICsKICBnZW9tX3BvaW50cmFuZ2UoYWVzKHltaW4gPSBzaWdfY2lfbG93ZXIsIHltYXggPSBzaWdfY2lfdXBwZXIpKSArCiAgZ2VvbV90ZXh0KHNpemUgPSAyLCB5ID0gMC4wNSwgY29sb3IgPSAiYmxhY2siKSArCiAgc2NhbGVfY29sb3JfYnJld2VyKHBhbGV0dGUgPSAiU2V0MiIpICsKICB5bGltKDAsIDEpICsKICB0aGVtZV9idygpICsKICB0aGVtZShheGlzLnRleHQueCA9IGVsZW1lbnRfdGV4dChhbmdsZSA9IDQ1LCBoanVzdCA9IDEsIHZqdXN0ID0gMSksCiAgICAgICAgbGVnZW5kLnBvc2l0aW9uID0gIm5vbmUiKSArCiAgbGFicyh0aXRsZSA9ICJDbHVzdGVyaW5nIHdpdGggYWxsIHZhcmlhYmxlcyBTSUdOSUZJQ0FOQ0U6IE1lYW4gcmVzcG9uc2UgdG8gaG93IHNpZ25pZmljYW50IGV4cGVyaWVuY2Ugd2FzIGNvbnNpZGVyZWQiLAogICAgICAgc3VidGl0bGUgPSAiQnkgc2l0ZSAocm93cyksIHF1ZXN0aW9uICh4LWF4aXMpLCBhbmQgbGV2ZWxzIDEtMiBncm91cGluZyBvZiBjbHVzdGVycyAoY29sdW1ucylcbk51bWJlcnMgZm9yIGVhY2ggcXVlc3Rpb24gaW5kaWNhdGUgdGhlIHRvdGFsIG51bWJlciBvZiBwYXJ0aWNpcGFudHMgZnJvbSB0aGF0IHNpdGUgd2hvIHJlc3BvbmRlZCB0byB0aGF0IHF1ZXN0aW9uOyBlcnJvciBiYXJzIGFyZSA5NSUgYm9vdHN0cmFwcGVkIENJcyIsCiAgICAgICB4ID0gIlF1ZXN0aW9uIiwKICAgICAgIHkgPSAiU2lnbmlmaWNhbmNlICgwOiBub3QsIDAuNTogc29tZXdoYXQsIDE6IHZlcnkpIiwgY29sb3IgPSAiU2l0ZSIpCmBgYAoKCg==